import xlrd

class Read():

    def read(self,excelPath):
        self.data_list=[]

        self.excel=xlrd.open_workbook(excelPath)
        for sheet_index in range(0,3):
            self.tablePath=self.excel.sheet_by_index(sheet_index)
            all_row=self.tablePath.nrows
            for row_number in range(0,all_row):
                data_dict = {}
                read_url=self.tablePath.row_values(row_number)[0]
                read_data=self.tablePath.row_values(row_number)[1]
                read_except=self.tablePath.row_values(row_number)[2]
                data_dict["url"]=read_url
                data_dict["data"] = read_data
                data_dict["except"] = read_except
                self.data_list.append(data_dict)

        # print(self.data_list)
        return self.data_list


if __name__ == '__main__':
    read=Read()
    read.read("dates.xlsx")